package model.dao;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import model.vo.AssetBaseVO;
import model.vo.AssetImpotantVO;
import model.vo.AssetListVO;
import model.vo.AssetPercenTageVO;
import model.vo.AssetScVO;
import model.vo.JobProcessVO;
import model.vo.OptinfoVO;
import model.vo.PyungBaseVO;




public interface AssetDAO {
	//[자산 평가 IPO]
	//1.카탈로그
	//(자산분류기준)
	public List assetBase() throws SQLException;
	public Integer assetBase_maxNo() throws SQLException;
	public void assetBase_insert(AssetBaseVO vo) throws SQLException;
	public void assetBase_delete(int asset_no) throws SQLException;
	public AssetBaseVO assetBase_updatePage(int asset_no) throws SQLException;
	public void assetBase_update(AssetBaseVO vo) throws SQLException;
	//(업무프로세스)
	public List jobProcess() throws SQLException;
	public Integer jobProcess_maxNo() throws SQLException;
	public void jobProcess_insert(JobProcessVO vo) throws SQLException;
	public void jobProcess_delete(int job_no) throws SQLException;
	public JobProcessVO jobProcess_updatePage(int asset_no) throws SQLException;
	public void jobProcess_update(JobProcessVO vo) throws SQLException;
	
	//2.평가기준
	//(업무프로세스중요도)
	public List pyungBase() throws SQLException;
	public Integer pyung_maxNo() throws SQLException;
	public void pyung_insert(PyungBaseVO vo) throws SQLException;
	public void pyung_delete(int no) throws SQLException;
	public PyungBaseVO pyung_updatePage(int no) throws SQLException;
	public void pyung_update(PyungBaseVO vo) throws SQLException;
	//(자산중요도평가기준)
	public List assetImpotant() throws SQLException;
	public Integer assetImpotant_maxNo() throws SQLException;
	public void assetImpotant_insert(AssetImpotantVO vo) throws SQLException;
	public void assetImpotant_delete(int impo_no) throws SQLException;
	public AssetImpotantVO assetImpotant_updatePage(int impo_no) throws SQLException;
	public void assetImpotant_update(AssetImpotantVO vo) throws SQLException;
	//(자산보안등급평가)
	public List assetSecurity(String gubun) throws SQLException;
	public Integer assetSecurity_maxNo(String gubun) throws SQLException;
	public void assetSecurity_insert(AssetScVO vo) throws SQLException;
	public void assetSecurity_delete(AssetScVO vo) throws SQLException;
	public AssetScVO assetSecurity_updatePage(AssetScVO vo) throws SQLException;
	public void assetSecurity_update(AssetScVO vo) throws SQLException;
	
	//3.자산 식별 및 평가 
	//(자산식별)
	public List assetIdenty_list(AssetListVO vo) throws SQLException;
	public boolean searchAcd(String a_cd) throws SQLException;
	public void assetIdenty_insert(AssetListVO vo) throws SQLException;
	public void assetIdenty_insertOpt(OptinfoVO vo) throws SQLException;
	public void assetIdentyDelete(String deleteA_cd) throws SQLException;
	public void assetIdentyOptDelete(String deleteA_cd) throws SQLException;
	public AssetListVO assetIdenty_updatePage(String a_cd) throws SQLException;
	public OptinfoVO assetIdentyOpt_updatePage(String a_cd) throws SQLException;
	public void assetIdenty_update(AssetListVO vo) throws SQLException;
	public void assetIdenty_updateOpt(OptinfoVO vo) throws SQLException;
	//(자산평가)
	public List assetResult_list(AssetListVO vo) throws SQLException;
	public List sc_score(String gubun) throws SQLException;
	public AssetListVO assetResult_updatePage(String a_cd) throws SQLException;
	public void assetResult_update(AssetListVO vo) throws SQLException;
	//(자산 목록)
	public List assetList(AssetListVO vo) throws SQLException;
	//public float percenTage(HashMap map) throws SQLException;
	public Map counts(HashMap map) throws SQLException;
	public AssetPercenTageVO percenTage(AssetPercenTageVO vo) throws SQLException;
}
